Foreign key

A FOREIGN KEY is a field or fields in a related table containing values matching the values in the primary key field of the primary table. In a one-to-many relationship, the primary key field identifies each record on the ''one side'' of the relationship, while the foreign key field identifies each record on the 'many side' of a relationship.